Problem Note 59465: SAS® Risk and Finance Workbench changes to support IFRS9 content release
The following software updates are needed in SAS Risk and Finance Workbench to support the IFRS9 content release.
- Add checks for hierarchy node names to avoid exact duplicates, which results in a blank hierarchy.
- Add "Legal Entity Identifier" (LEI) column to uploaded hierarchies so that the produced XBRL includes the LEI.
- Allow sheets to have no rows of data and to load data for sheets that do have data.
- Load data in the proper order so that worksheets show data whether scenarios are on the X or Y axis.
- Ensure user ID/password usage in mid-tier and SAS session for authentication when executing code within a Script of a Model Group.
- Make Taxonomy Hierarchy category definitions function correctly in upgrade from SAS Risk and Finance Workbench 2.2 release to the 2.3 release.
- Ensure the path to the workgroup is created correctly when a workgroup is specified.
- Ensure that properties are updated appropriately when adding and modifying software components.
- Ensure that component properties are created and can be modified appropriately in metadata.
- Update values properly when overrides are applied to even and equal allocation methods so as to update subtotal and update child node cells in a worksheet.
- Ensure that filter values specified by users are honored in the _OG() macro.
- Update the allocation script so that the allocation rule is "Proportional or Even" instead of "Relative or Equal." The default is now Proportional.
- Improved log messaging if Taxomony tables are not set up correctly.
- Display validation error text when hovering over a cell if a validation error has occurred.
- Honor currencies as needed when previewing the landing area data, not just the current currency.
- Make drilldown in sample code consistent in Postgres and Oracle databases for zero-length strings.
Operating System and Release Information
| SAS System | SAS Risk and Finance Workbench | Microsoft® Windows® for x64 | 2.3 | 2.4 | 9.4 TS1M4 | 9.4 TS1M4 |
| Linux for x64 | 2.3 | 2.4 | 9.4 TS1M4 | 9.4 TS1M4 |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
Changes are needed in SAS Risk and Finance Workbench to support the IFRS9 content release.
| Type: | Problem Note |
| Priority: | high |
| Topic: | Analytics ==> Financial Analysis
System Administration ==> Servers ==> Metadata
|
| Date Modified: | 2016-12-22 10:26:00 |
| Date Created: | 2016-12-06 14:01:42 |
